\~\~With many of THE CALLING TREE's search options you may:
\~\~ADD the results of this particular search to the current SubSet. If working from the main database, a new SubSet will be created with only the found records. or...
\~\~SUBtract the results of this particular search from the current SubSet. If working from the main database, a new SubSet will be created minus the found records. or...
\~\~NEW, will create a whole new SubSet with only those records meeting your search specification, working from the current file.
\`DATEOPT
\|DATE OPTIONS
\~\~FROM..TO: Will allow you to retrieve a range of dates in the specified date field working from the current database.
\~\~ANY DATE: Will retrieve all records with any date in the specified date field. If the field is empty the record is skipped.
\~\~ALL RECORDS: Will retrieve all records regardless of whether there is a date in the specified field or not.
\~\~EMPTY DATE: Will retrieve only those records where the specified field is empty.
\`DATEFLD
\|SPECIFY SEARCH FOR WHICH DATE FIELD?
\~\~Enter the Date Field Letter that you want to conduct the search for.
\~\~Optionally: [TAB], [SHIFT-TAB], or [Left/Right Arrow] to the correct date field label. [ENTER] or [RETURN] or [Down Arrow] accepts.
\`SORT
\|SORT ORDER
\~\~Specify {A}-Ascending Sort Order or {D}-Descending Sort Order
\`DATEEMPTY
\|SEARCH FOR .....
\|PRESENCE, ABSENCE OR ANY DATE
\~\~The CALLING TREE may look for the presence of, absence of or any date in a date field.
\~\~{D}-Look for presense of date in field
\~{N}-Look for empty date field.
\~{A}-Look for ALL records with any information in this date field
\`BEGINDATE
\|FROM or BEGINNING DATE
\~\~The program needs two dates in order to bracket a search. Finding all dates that are between these two dates.
\~\~Enter the starting date in the format 'MM/DD/YY'. This is the date that the search will start with.
\~\~If you leave this date field blank then the program will enter a default date of '01/01/01'.
\~\~You may optionally find all records with an empty date in 'A,B,C,D or E' Date field sorted by last name/first name just by placing a question mark ('?') in the begin date field.
\`ENDDATE
\|TO or ENDING DATE
\~\~The program needs two dates in order to bracket a search. Finding all dates that are between these two dates.
\~\~Enter the ending date that you want in the format 'MM/DD/YY'. This is the date that the search will end with.
\~\~If you leave this field empty then the program will insert today's date as default.
\`SORTSTART
\|Start the search/sort
\~\~Press the [ENTER] or [RETURN] key to start this search/sort operation.
\~Pressing [F9] will change to the previous date field label, while [F10] will change to the next date field label.
\`BUZZWORDR
\|KEY WORD or PHRASE SEARCH
\|- Whole Record Search Operators -
\~\~THE CALLING TREE allows the user a great deal of flexabilty in searching for members in database. The search may be performed on the whole record or on a specific field. Each search may have several components. A) The {ADD}, {SUB} operators, says whether to Add or Subtract the results, B) {AND}, {OR}, {NOT} says that the subsequent string meet certain And, Or, Not qualifications, C) One or more search words or phrases separated by a ';'. The format is as follows
\~\~Search form and Components...
\~\+{P} {S} str1 [; str2; .... ; strN]
\~\~----------------------------------
\~{P} = Primary Component (Optional)
\~----------------------------------
\~Two (2) Optional Search Operators, if used, must be placed at the VERY beginning of a search string....
\~\~\+{ADD} or {+
\~Is used to add records to the working subset database. Is placed at the beginning of the word or phrase. An {ADD} is ignored if there is no active SubSet database. Records are always added from the full database and the add is ignored if the record all ready exists in the subset.
\~\~\+{SUB} or {-
\~Is used to subtract records from the current subset database. Is placed at the beginning of the word or phrase. A {SUB} will create a subset database (without the records indicated) if there is no current subset database, otherwise the {SUB} will merely subtract the desired records from the current subset database.
\~Example: {ADD} Peach; Apple = will search the selected area of the file and add all records to the search subset where either 'Peach' OR 'Apple' occur.
\~\~------------------------------------
\~{S} = Secondary Component (Optional)
\~------------------------------------
\~Three (3) Optional Search Operators, if used, must be placed just before any search words or phrase.
\~\+{AND} or {&
\~This finds all the strings in a search 'Boulder {and} Longmont'.
\~\+{OR} or {~
\~This finds any of the string(s) in a search. 'Boulder {or} longmont'.
\~\+{NOT} or {!
\~This finds the first string but 'NOT' the any subsequent string(s). 'Boulder {not} longmont'.
\~\~Example: {SUB} {AND} Peach; Apple = will search the selected area of the file and subtract (remove) all records from the temporary search subset where both 'Peach' AND 'Apple' occur.
\~\~------------------------------------------
\~Search String(s) Str1 [; str2; ..... strN]
\~------------------------------------------
\~StrX represent the strings (words or phrases) you are looking for.
\~\~Examples:
\~Blueberry; Red Apple; Green Grape; Peach
\~{ADD} Boulder {OR} Colorado Springs
\~{+ Cleveland {AND} Chicago
\~{SUB}Cute {AND} Intelligent
\~\~Rules:
\~All strings must be separated by an ';' colon.
\~Maximum number or search strings is 20 in any one search event.
\~'{NOT str1' is treated as a '{SUB} str1'.
\~'{NOT} str1; str2' is treated as Find st1, NOT str2.
\~\~Other search parameters of interest may be Case Sensitivity and Exact Work Match.
\~Cursor to 'Exact' and 'Case Sensitive' to read help for those specific situations.
\`SCREEN6
\|BUILD SUBSET BY LEVEL/QUEUE/GROUP
\~\+Select MemberS By ...\~
\+----------------------\~
\+'L' = Level from Top of Tree\~
\+'Q' = Family Queue Size, or\~
\+'G' = Overall Group Size
\~\~Enter a number in the appropriate field (Greater Than, Equal or Less Than) then press [ENTER] or [RETURN]. The Calling Tree will show you a window of members meeting your specifications.
\`UPMASSYN
\|CONFIRM MASS UPDATE OF SPECIFIED DATABASE FILES
\~\~Just Enter 'Y' for YES here. All selected or specified files will be updated with the new information in the indicated field.
\~\~Just Enter 'N' for NO here. The update procedure will be cancelled.
\~\~Caution! You cannot cancel the update procedure once it has started. Be very sure you are doing exactly what you want.
\`SCREEN7
\|MASS UPDATE OPTION
\~\~This option will enable you to update the entire current working file by placing a specified word or phrase in any field of your choosing. The new information replaces the data in the specified field with the exception of the 'Comments' field. The new information will be tacked on to the end of any information in the Comments field.
\~\~If you leave this field blank then the update process will blank out the appropriate field in the file.
\~\~MAY-MAY NOT
\~You MAY NOT place a non-date in to a date field during mass update. You MAY place a date in to a non-date field. You will be notified, but it will be allowed.
\~\~Changing Field Labels:
\~Pressing [F9] will change to the previous date field label, while [F10] will change to the next date field label.
\~\~Exception: The ID field is not available for updating.
\`SORTORD
\|SORT ORDER PREFERENCE
\~\~You may resort the database on any field ASCENDING or DESCENDING. Select 'A' or 'D' here to start the resort. Press 'ESC' to cancel sort.
\`BUZZWORDF
\|KEY WORD or PHRASE SEARCH
\|- Field Search Operators -
\~\~THE CALLING TREE allows the user a great deal of flexabilty in searching for members in database. The search may be performed on the whole record or on a specific field. Each search may have several components. A) The {ADD}, {SUB} operators, says whether to Add or Subtract the results, B) {AND}, {OR}, {NOT} says that the subsequent string meet certain And, Or, Not qualifications, C) One or more search words or phrases separated by a ';'. The format is as follows
\~\~Search form and Components ..
\~\+{P} {S} str1 [; str2; .... ; strN]
\~\~----------------------------------
\~{P} = Primary Component (Optional)
\~----------------------------------
\~Two (2) Optional Search Operators, if used, must be placed at the VERY beginning of a search string....
\~\+{ADD} or {+
\~Is used to add records to the working subset database. Is placed at the beginning of the word or phrase. An {ADD} is ignored if there is no active SubSet database. Records are always added from the full database and the add is ignored if the record all ready exists in the subset.
\~\+{SUB} or {-
\~Is used to subtract records from the current subset database. Is placed at the beginning of the word or phrase. A {SUB} will create a subset database (without the records indicated) if there is no current subset database, otherwise the {SUB} will merely subtract the desired records from the current subset database.
\~\~Example: {ADD} Peach; Apple = will search the selected area of the file and add all records to the search subset where either 'Peach' OR 'Apple' occur.
\~\~------------------------------------
\~{S} = Secondary Component (Optional)
\~------------------------------------
\~Six (6) Optional Search Operators, if used, must be placed just after Primary operator {A} (above) and before any search words or phrase.
\~There are three operators in their own special catagory for field related searches only.
\~\~They are '{}','{!','{*'. They are used by themselves (no search string follows).
\~\+'{}'
\~The '{}' is placed in the search field to signify a completely empty record field. This operator may not be used in the full record search mode. It will retrieve all records with the specified field being empty.
\~\+'{*'
\~The '{*' is placed in the search field to signify a record field with any information in it (the field is Not Empty, opposite of '{}'.
\~\+'{?'
\~The '{?' is placed in the search field to signify a record field with any condition (the field is may or may not be empty, includes both '{}' and '{*'.
\~\~The other three operators are...
\~\+{AND}, Optional '{&'
\~This finds all the strings in a search 'Boulder {and} Longmont'.
\~\+{OR}, Optional '{~'
\~This finds any of the string(s) in a search. 'Boulder {or} longmont'.
\~\+{NOT}, Optional '{!'
\~This finds the first string but 'NOT' the any subsequent string(s). 'Boulder {not} longmont'.
\~\~-------------------------------------------
\~Seach String(s) - Str1 [; str2; ..... strN]
\~-------------------------------------------
\~StrX represent the strings (words or phrases) you are looking for.
\~\~Examples:
\~Blueberry; Red Apple; Green Grape; Peach
\~{ADD} Boulder {OR} Colorado Springs
\~{+ Cleveland {AND} Chicago
\~{SUB}Cute {AND} Intelligent
\~\~Rules:
\~All strings must be separated by an ';' colon.
\~Maximum number or search strings is 20 in any one search event.
\~'{NOT str1' is treated as a '{SUB} str1'.
\~'{NOT} str1; str2' is treated as Find str1, NOT str2.
\~\~Other search parameters of interest may be Case Sensitivity and Exact Work Match.
\~Cursor to 'Exact' and 'Case Sensitive' to read help for those specific situations.
\~\~Examples: ..........
\~{ADD} Boulder {OR} Colorado Springs
\~{+Cleveland {AND} Chicago
\~{ADD}{}
\~* Will add all records where this field is empty.
\~{SUB}Cute {AND} Intelligent
\`EXACT
\|EXACT MATCH
\~\~You may look for an Exact Match of the search string below or you may look for some part of the below information in the field specified above.
\~\~Example: Exact Match="Y"
\~Find: '555-1234' in work phone number will only match and find '555=1234'.
\~\~Example: Exact Match="N"
\~Find: '555-123' will find all numbers with '555-123' in them (303-555-1234, 555-123-6666, etc).
\~\~Exception: Range 'a..b', Empty or Not Empty field searches will ignore the 'Exact' Match preference.
\`CASESEN
\|CASE SENSITIVE SEARCH
\~\~'Y' Yes, do a Case Sensitive Search
\~'N' No, do a Case In-Sensitive Search
\~\~If capitalization of any word or phrase makes a difference in your search then choose 'Y'.
\`EMPALL
\|UPDATE BASED ON 'EMPTY' FIELDS
\~\~During mass update the program will by default select all records for updating with the specified word or phrase. If you place an 'E', only those records that have an empty field here will be updated.
